Re: shared memory on OS X - 7.4beta4 - Mailing list pgsql-general

From Jim Crate
Subject Re: shared memory on OS X - 7.4beta4
Date
Msg-id r02000200-1030-A5719B5A095D11D899740003939CD378@[63.175.177.209]
Whole thread Raw
In response to Re: shared memory on OS X - 7.4beta4  (Alvaro Herrera Munoz <alvherre@dcc.uchile.cl>)
Responses Re: shared memory on OS X - 7.4beta4  (Eric Soroos <eric-psql@soroos.net>)
List pgsql-general
>> And here are are the default settings for OS X 10.2.6:
>>
>>     sysctl -w kern.sysv.shmmax=4194304
>
>Well, I can only say that if I lower shmmax to that value, initdb picks
>max_connections = 50
>shared_buffers = 300

I just did a fresh install of 7.4b5 on a fresh install of MacOS 10.3, and initdb
picked those same values for postgresql.conf.  PostgreSQL started up the first
time successfully, but then refused to start again even after restarting the
computer until I reduced shared_buffers.

Now to figure out why sysctl -w kern.sysv.shmmax=<some_reasonable_value> doesn't
seem to work on 10.3...

Jim Crate

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Newbie-question
Next
From: Fernando Nasser
Date:
Subject: Re: Versioning control in PostgreSQL?